0

Pulling Sales Order Number from Transactions with GL Code 5990 / 5992

Adam Greco

March 31, 2018 01:23

None

Follow

Hi everyone,

I'm way over my head with this request, but we use GL 5990 for inbound freight and 5992 for outbound freight. I need to make sure our FedEx invoices balance to what we charge customers for freight (actual cost), so I was wondering if it's possible to design a Jet Report that reports all Sales Order numbers that are associated (entered as a line item on) with a GL on posted sales invoices.

If possible, does anyone have a good idea on where I should start. I'm still very green with Jet. I understand the logic when reading through someone's work, but I still struggle with setup!

 

Best,

Adam

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis April 13, 2018 20:29

  Hi Adam - 

  You could probably get what you need from the GL entry table.  It should have to document number and the GL account number. 

   

  From Microsoft MSDN: 

  Document No. in G/L Entry

  “If the entry was posted from an order, invoice or credit memo, the program automatically assigned the entry a number from the number series in the Posting No. Series field on the sales or purchase header. If the Posting No. Series field was empty, the number was copied from the No. field on the sales or purchase header.”