For the transactions posted in the first identified day, change the tax period. Option 1: Manually Open developer workspace go to AOT> Data Dictionary >Tables > select TaxTrans > field: TaxPeriod - change the properties: AllowEdit and AllowEditOnCreate to YES and save changes Open table TaxTrans > search for all transactions posted on identified day (field TransDate) and change the TaxPeriod to but just for few, i.e. on all with specific Tax “TEST” Code or where the source is the same (sales order, voucher, purchase order, free text invoice, or tax origin (sales tax, cash discount) …) Option 2: Tax period modified by script Open developer workspace > AOT > Jobs > create new and write code Run it and the results Result can be checked in TaxTrans table Run again the sales tax payment for the settlement period for the same day and check if the “old” issue still exist. If issue occurs, repeat step 1.6 (1 or 2) for next part of transactions posted on the identified day If the disappear, proceed with below: Export the transactions to excel just to remember them Change back the setup and set tax period for first one and run the sales tax payment “TEST” for period “Test” Hint: To do not create new settlement period each time when it will be posted, we can just modify data in Table > TaxReportPeriod Change on the field and the properties and to ”Closed” “VersionNum” “AllowEdit” “AllowEditOnCreate” YES Open the TaxReportPeriod and unmark checkbox in Closed column and change version form 1 to 0 On TaxPeriod “TEST” After change:
For the transactions posted in the first identified day, change the tax period. Option 1: Manually Open developer workspace go to AOT> Data Dictionary >Tables > select TaxTrans > field: TaxPeriod - change the properties: AllowEdit and AllowEditOnCreate to YES and save changes Open table TaxTrans > search for all transactions posted on identified day (field TransDate) and change the TaxPeriod to “TEST” but just for few, i.e. on all with specific Tax Code or where the source is the same (sales order, voucher, purchase order, free text invoice, …) or tax origin (sales tax, cash discount) Option 2: Tax period modified by script Open developer workspace > AOT > Jobs > create new and write code Run it and the results Result can be checked in TaxTrans table Run again the sales tax payment for the “old” settlement period for the same day and check if the issue still exist. If issue occurs, repeat step 1.6 (1 or 2) for next part of transactions posted on the identified day If the disappear, proceed with below: Export the transactions to excel just to remember them Change back the setup and set “TEST” tax period for first one and run the sales tax payment for “Test” period Hint: To do not create new settlement period each time when it will be posted, we can just modify data in Table > TaxReportPeriod Change on the field ”Closed” and “VersionNum” the properties “AllowEdit” and “AllowEditOnCreate” to YES Open the TaxReportPeriod and unmark checkbox in Closed column and change version form 1 to 0 On “TEST” TaxPeriod After change:
TroubleshootingSalesTaxPayment.docx