Update Sales Transactions Distributions From Item

Microsoft Dynamics GPThis is a script I’ve had a few months now and, like the one I posted yesterday, thought it might be useful to others.

This script was created for a client who changed some of their account codes on some Item Classes and had rolled them down to the Items themselves but there were many Sales Transactions already on the system which had the old code on and needed to be updated to the new one.

Continue reading “Update Sales Transactions Distributions From Item”

Missing Transaction In Cashbook Bank Management?

Microsoft Dynamics GPI dealt with an issue yesterday where a manual payment had been entered into Payables Transaction Entry (Transactions ¯ Purchasing ¯ Transaction Entry) but was not showing up in Bank Management’s Reconciliation screen (Transactions ¯ Financial ¯ Bank Management ¯ Reconciliation).

The reason for this is actually quite simple, but I can’t help but feel it is a little bug like. Only payments made directly via Transaction Entry or those produced during the payment run (Transactions ¯ Purchasing ¯ Select Cheques) are posted to Bank Management. If you need to do a manual payment into Payables, or a manual receipt into Receivables, then this needs to be done via CBM Batch Entry (Transactions ¯ Financial ¯ Bank Management ¯ Batches) Continue reading “Missing Transaction In Cashbook Bank Management?”

Locked Payables Transaction: You cannot display this record while another user is editing it

Microsoft Dynamics GPWith sites using Microsoft Dynamics GP over Citrix Presentation or XenApp, where they have set Citrix to time users out after a certain period of inactivity, we occasionally see the following error message when another user tries to open the voucher in Payables Transaction Entry (Transactions ¯ Purchasing ¯ Transaction Entry);

This document number already exists. Please enter a new document number.

Continue reading “Locked Payables Transaction: You cannot display this record while another user is editing it”