255
The GP Trial Balance Report shows the Orig. Master Number associated with each transaction. This is either the Receipt # or the Invoice Number. What I really need to show is the Purchase Order # associated with each GL transaction. I have tried to build a similar report in Smartlist Builder but have not been successful. Does anyone have any ideas to get me started in the right direction?
Thanks!
*This post is locked for comments
There is Customization Site Enabler and Modifier. If you have SLB you can create the link between the GL20000 and POP10500 tables.
We have Business Essentials. I don't see any options for "Modifier" when looking in the Registration section. We do have Smartlist Builder. Also, we have trouble using SSRS because we have Account Level Security turned on.
Again thank you for your help.
Sandip, can you think of anyway the GL IV balance would get out of sync with the purchase receipts report given that the GL IV account and item type is set correctly for all items? This is how I knew to use the POP10500 table as I just had to write scripts to find out what may be causing the differences.
Are you licensed for Modifier? Are you on GP Standard, Professional, Business Essentials or Advanced Management? Go to Tools->Setup->System->Registration and see what is registered or you can log into CustomerSource. If you are not registered for Modifier perhaps you have SmartList Building. If not, then SSRS would be the way to go.
Thank you again for your reply. The Add Report to Visual Basic link is greyed out and not an active link on our system. Do you know why or how I can change that?
Thanks!
Yes POP10500 table can use. I think POP10500 table is right table it shows more row count then POP30310.
Thanks much for your clarification Mr.Richard.
Thanks
Sandip
Sandip, can he also use the GL20000.ORCTRNUM field to link to the POP10500 table and on the matching record will be the PO number? The ORCTRNUM field is the Receipt number from either the PO ship or invoice receipt.
Sure, Add report into VBA-- Print Report on Screen--> Modify, Goto -->Tools-Add Report to Visual Basic. I will recommend to add calculated field to display PO #, so user can see Receipt # and PO # both. Add Master ID (Reciept # field) to VBA, you need to select require field and then goto tools-->Add field to VB.
Then write your VBA code to populate PO# field (Calculated field). POP30310 is hold Receipt Number and PONumber.
This link will help you to understand how to add report into VBA etc: blogs.msdn.com/.../using-vba-with-report-writer.aspx
Let me know how it goes.
Thanks
Sandip
Thank you! Would you be able to expand more on this answer, so I can give some more information to our IT Dept to try and write the code?
Through vba coding you can do it.
Thanks
Sandip
Share
Report
All responses (
Answers (
