GRNI to GP Extract
Extract
The GRNI to GP Extract shows a record of any “On Account†payments, showing the account nominal codes rather than account allowing your accounts team to easily identify the exact account to charge. The account number is built up of a prefix and account type code, which can be setup under the GP configuration program in the back office under the “accounts†menu. The account reference will then be broke down further dependent on if a nominal code is setup for the specific departments that the items under the transaction OR, if it’s a till transaction, the store code prefix and then the payment method. If the line is referencing a credit back to the customer, it will only show the account type or branch prefix. The “reference†column shows the batch number, identifying all transactions that were processed at the same time.
GP Configuration
All the account details are configurable in the back office, under the “GP Configuration†program. The first section in the program allows you to set codes for the company’s VAT and Retail account. You will then have the option to add the codes for each department. For each department you can add the Prefix for each branch, as well as a VAT ex Income nominal code and a code that links to the cost sales against that Department/Branch combination.
You will also have the option to set the prefix and nominal code for each payment method for online payments, as well as a prefix and nominal code for each till branch and payment method.
Related Articles
Extracting a list of Product Web Descriptions
This report can be useful if you need to review all of your product web descriptions in a single spreadsheet or if you need to send a list of descriptions to be translated to a different language. To run the Catalogue Extract go to the Reporting Menu ...Extract Customer Information
To extract customer information you can go into Customer Database - Customer Database Extract Within here you can enter specific date ranges among other details and will include email address' for contact purposes. The below screenshot shows the ...Customer Order Status Extract v2
Summary The Customer Order Status Extract v2 provides a comprehensive breakdown of all orders processed through the web or telesales channels. This report includes details such as order number, third-party order number, customer's name, recipient ...Dynamics GP Purchase invoice Troubleshooting
Question: Hi Team, Purchase Invoice integration into Dynamics failed last night, with the following error message..... BATCH 12342 -- Document Number 736066: Procedure or function taPMTransactionTaxInsert expects parameter @I_vVENDORID, which was not ...Product Amendment Import/Export
Product Amendment Import/Export The import / export utility has been created to allow for easy updating of a products descriptions, department/sub department and min/max level, loyalty redemptions, bar form till . The program sits under Stock: Style ...