Sage 100

 View Only
Expand all | Collapse all

Cash Receipts import - header & line detail in sam

  • 1.  Cash Receipts import - header & line detail in sam

    Posted 01-10-2017 15:49
    Cash Receipts import - header & line detail in same row. v2017. Failing on the Deposit number, which I have created a column for, and sequentially numbered each row. I tried as a single digit and as a text field with 5 characters. Same failure message. I'm not sure that's actually the problem, but I haven't found answer here or in Sage City or the KB. The exact message is ""HS Record Invalid or Write Failed. The Deposit Number is required."" Batches are not turned on. By the way, I am entering data in CR as pre-payments. I created a CR manually and looked at the data in DFDM. Looks like what's in my file, so I'm not sure what's going on.


  • 2.  RE: Cash Receipts import - header & line detail in sam

    Posted 01-10-2017 15:53
    Split CR import into two jobs. One for AR CR Deposit file and the other for AR CR Header.


  • 3.  RE: Cash Receipts import - header & line detail in sam

    Posted 01-10-2017 15:54
    Ok, I'll give that a shot. Thanks.


  • 4.  RE: Cash Receipts import - header & line detail in sam

    Posted 01-10-2017 16:04
    Yay! That did it. Thanks @MoiraGoggin.