I'm using Progression 7.6.400b on MS SQL 2000. Many of the customers have terms (due and discount) that can't be calculated simply by adding a number of days to the invoice date. We use the capability in Progression to specify a specific due and discount date for a particular terms code and we update that terms code dates associated with the terms code using a scheduled SQL agent job. Example due date is the 25th of the next month and discount date is the 10th of the next month. Terms code is 2% 10th Net 25th. The transaction stores the due date in the AROPNFIL table but uses the SYCDEFIL to look up the terms when applying cash reciepts. THis results in issues since the discount date will often have changed by the time cash is applied and is almost always a future date when the cash is applied. Obviously there are problems when the discount date and discount amt. are not stored with the transaction.
Has anyone had to deal with this issue? And how has it been addressed. I'm dealing with it now because I have Trading Partners on EDI that want it to be included in the 810.
Has anyone had to deal with this issue? And how has it been addressed. I'm dealing with it now because I have Trading Partners on EDI that want it to be included in the 810.