Sales Update Log

 

In WMS, version 4.5x each record will be accompanied by a Division ID, a date/time stamp, and a Boolean flag indicating whether the record has been sent to the sales center (F=False, or not sent, T=True, or sent).  

 

 

In the Action column:

I=Insert:  We are asking the sales center to insert this item because it is a new item.  On initial sends, everything would be listed as an I.

U=Update:  We are asking the sales center to update this item.

D=Delete:  We have created an entry that asks the sales center to delete this item.

 

Inserts and updates will both be handled as inserts for Builder1440 (except for the Builder node, which will handle both as defined above).

 

Additionally, when a user in division A does a send, only the data in the SALES_UPDATE table marked for division A will write to the .XML file.  Data for other divisions will remain unwritten to the .XML file until a user in that division performs a send.  Data will persist in the table until it is cleared by the new Sweep Update Log function.

When items are in the SALES_UPDATELOG the Initial Send (Send All) procedure is disabled.

 

The Sales Update log is accessible at Tools > SQL Pad.

 

For additional information click the topic below, Approving Sales Contracts.