Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
bbm 3/7/2019 10:05:36 AM

Check logic on import tool

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  


Version: All
Section: Dynamics GP








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables