I'm writing a sales order import tool for GP 2018. I'm needing to know if the logic below is right, or if I'm missing something.
Import Logic
read headers
|
does customer exist?
NO YES
| |
| |
create new customer |
| |
insert records into |
RM00101, RM00102, |
RM00103 |
| |
check if order already exists
(export systems allow duplicates)
NO YES
| |
| exit
|
check for batch
or create new - lock batch
SOP00500
|
insert record into
SOP10100
SOP10101
SOP10102 - 2 entries, one with
account reference for Sales
and one with the reference for
accounts receivable
SOP10103
SOP10106
SOP10112
|
loop through line items
insert records into
SOP10200
SOP10105
|
update batch totals and unlock
SOP00500