I have a customer that uses the Jobs legder to do most of their work. They are happy that the Revenue is split up into the Revenue accounts as per the IPG’s, but not happy that the costs for the jobs are only posted to one G/L account. Has anyone done any work on this? I need to be able to ‘get job usage’ then invoice as per normal so that the costs get allocated across the numerous inventory cost accounts. John Curtain Business Analyst HLB Consulting - Information Systems Level 32, Nauru House 80 Collins St Melb VIC 3000 Ph: +61 3 9258 6745 Fax: +61 3 9258 6722 Mob: 0411 511 951
Hi, I think you mean Sales account (G/L Exp. Sales Account field in Job Posting Group), not cost account. When you post Job usage (cost) you can allocate it on different cost accounts. When you post Sales Invoice you post Job Sales. If you want post Sales for G/L Expences on differents accounts you need create field G/L Exp. Sales Account in any table: Work Type - if you want allocate by work type; Department - if you want allocate by Department Code; Project - if you want allocate by Department Code; Reason Code… Task… Phase… Step… General Posting Setup… and change code in report 294 Get Job Usage function FinalizeJobPostingBuffer . As Example for Work Type Code : Previouse Code:
IF "Posting Group Type" = 2 THEN BEGIN // G/L
Job.GET("Job No.");
Job.TESTFIELD("Job Posting Group");
JobPostingGr.GET(Job."Job Posting Group");
JobPostingGr.TESTFIELD("G/L Exp. Sales Acc.");
SalesLine."No." := JobPostingGr."G/L Exp. Sales Acc.";
ELSE....
New Code:
IF "Posting Group Type" = 2 THEN BEGIN // G/L
IF "Work Type Code" <> '' then begin
WorkType.GET("Work Type Code");
WorkType.TESTFIELD("G/L Exp. Sales Acc.");
SalesLine."No." := WorkType."G/L Exp. Sales Acc.";
end else begin
Job.GET("Job No.");
Job.TESTFIELD("Job Posting Group");
JobPostingGr.GET(Job."Job Posting Group");
JobPostingGr.TESTFIELD("G/L Exp. Sales Acc.");
SalesLine."No." := JobPostingGr."G/L Exp. Sales Acc.";
end;
end else...
Valentin Gvozdev BMI Inc. Edited by - Valentin Gvozdev on 2/29/00 8:50:36 PM