Error when Posting Sales Transaction Entry in Dynamics GP

Before posting the Sales Transaction, users should print out the Edit List report for final checking and verification.

1. To print Sales Transaction Entry Edit List, go to:-
Path: Transaction > Sales > Sales Batches

2. Select the batch that need to post from <Batch ID>, and then select [Print] to generate the Edit List Report.

3. In the Sales Document Print Options, select “Edit List” from <Form to Print>. Then select [Print].

4. In the Edit List report, if there is error in the transaction, it will be able to identify and provide the error message that shows you what is the actual error. Refer to the error identify below, the error indicates there are missing account code from the distribution entry.

5. To amend the error, go to the problem transaction in Sales Transaction Entry. Next, select the item in <Line Items by Order Entered>, then select Item Detail which is the Blue Arrow.

6. Then select [Distribution] in Sales Item Detail Entry screen.

7. You will notice there are empty field in the highlighted area. Make sure there is account code in each of the highlighted area. It doesn't matter what account code it is, system needs a default account code to be present here (provided the transaction is not dealing with Inventory). Once all the field is fill up with account code, select [OK].

8. Select [Save], select [Yes] when you see the following pop up message. Then continue to save the transaction and print out edit list to check again before posting.

Comments

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries. Path: Reports > Financial > Cross-Reference > Select "Journal Entries" Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry Path: Reports > Sal...

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for numerous accruals and reversals, allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches i. After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii. There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...

How to Record a Refund from a Vendor in Dynamics GP

Assuming you have scenario where there is over payment to your vendor or supplier, but you don't have any open invoice due to this vendor, you can simply enter a Return transaction using Payable Transaction Entry screen. Path: Transaction > Purchasing > Transaction Entry > Select "Return" from Document Type. 1. Assuming there is a refund of $100 from the supplier, enter the refund details as per screenshot attached. 2. Enter the refund amount to "Returns" and also "Check" field. 3. The check entry screen will pop out to record the cash receipt details. 4. Take note of the Distribution entry, DR Bank and CR Purchase. 5. After the Return is posted, the document status will be "HIST". No apply require. 6. This will also create a Bank Deposit to be deposited. (Transaction > Financial > Bank Deposits)

GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report. "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date. Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario. To perform Payable/Receivable Reconciliation Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL 1. Type in your date range. 2. Select “Module”, either Payable Management or Receivable Management. ...

Hello Dynamics! The most dynamics software that bring your business forward

Search This Blog