Sage 100

 View Only

I have an import that is pulling from a ASCii deli

  • 1.  I have an import that is pulling from a ASCii deli

    Posted 07-15-2014 08:43
    I have an import that is pulling from a ASCii delimited file. It is one a/p invoice represented by 4 rows each allocated to a different g/l account. I first import this to the vendor. This works fine. 1 invoice with 4 lines. I post it prior to proceeding with the second import. I then want to import the same file again to transfer the newly created invoice to a credit card vendor. The issue is I can not partially transfer the invoice. Business Logic requires to produce one line for the entire invoice that needs to be transfered. The first line imports as a transfer. The second line fails by business logic as ""being paid"". THE WEIRD PART is the third line will import and then the forth fails. If 2, 3, AND 4 failed, I would be fine as I can get line 1 to come in for the full invoice amount. There is nothing in the individual record that I can think of to condition to get it to ignore 2, 3, and 4. I do not want the client to have to modify the file before importing as it is a daily load and already too many steps. (Export and save out of one online system and then import into Sage 100 ERP 4.50.5) So, two thoughts. Is there a way to condition based on a prior record in Visual Integrator? Is there a way to get the business object to fail the additional 3 lines as ""being paid"" instead of every other line (seems broken to me)?