(select VENDORID, VCHRNMBR, CNTRLTYP, DEBITAMT, CRDTAMNT,ĭSTINDX, DISTTYPE, DistRef, PSTGDATE, CURNCYID, ![]() transaction tables and to clean up the code a bit Updated to fix GL posting date for Work trx Updated to add PM10300 and PM10400 tables Updated to add Vendor Name, GL Account Name currency, exchange rate and originating amounts Updated to add additional distribution types, Updated to add Batch ID, Trx Description, Updated to correct link to GL account number ![]() Transactions with no MC information will show ![]() Created by Victoria Yudin, Flexible Solutions Shows GL distributions for all AP transactions If you’re going to use this with SmartList Buidler, make sure to include the section at the end to grant permissions to DYNGRP. Unposted is also called ‘work’ and posted includes any open or historical transactions. Here is a view that will return the General Ledger distributions for all posted or unposted payables transactions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |