When we posting the WIP on 31/03/2022 creating some issues like these,
It has says “Unbalanced Journal Legal”. I tried to run again the WIP after obtain following solution
Changed formula on Automatic Journal > WIP > Line 35 > Amount from…
Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…
We have a contract that seems to be set up properly, but the contract amounts are not showing up in the WIP or job cost inquiries.
All items in the contract are approved and linked to a job. The job is set up for 'use contracts'. I found one difference…
How do you change the period of the over/under billing report so that you can only show a specific range. Our bonding agent needs a WIP report that only shows the first 6 months of the year.
I noticed that on the JC//Reports/Billing/WIP with cut-off date that the one of the commas is missing in the value e.g. $11,179,128 is showing as 11179,128.00 which is missing a comma between the million and thousand groupings. How do I fix it because…
We are currently Migrating from Sage 50 to Sage 100 and about to go live. We have one particular item we sell that we put as a job in Sage 50 where all costs go to WIP and then an Inventory adjustment puts the item into inventory. For clarification we…
Hi,
on Sage X3 v11, we are getting an error when posting the WIP of unbalanced journal
all the accounting codes are setup correctly. we've even put a default GL account on the chart of accounts to post to that account in case we've missed any important…
Update 9 Patch 8
Anyone know why WIP inquiry for a Product record includes purchase orders that have been invoiced and closed for back to back orders that have been delivered, invoiced and closed.
How do I change this, or what am I misunderstanding…
I use the automated notice via My Assistant called "Jobs with unbilled WIP older than 90 days" (we may have customized the length of time). I think it would be really helpful if the report could actually display the amount that is unbilled. (If for example…
WIP Posting automatically creates a journal entry. The entry is comes in as a temporary status.
Is it possible to have the journal entries go to the final status on its on. Or setup something that will do it?
Looking to optimize our prebill review process and would like to know if there is a way to track timekeeper efficiency with fewer workaround than we are currently using:
Example Project: Drafting document that includes text and drawings. Project budget…
Run FUNWIPACC (Costing, WIP, In-process posting) , WIP accounting interface. I am not able to select the work order option.
When I go into WIP Posting->Production Site>Entry Type it does not let me select the option Work Order.
When I enter…
1st time generating a mark up on a cost based invoice and I am having trouble with my mark up table, it does not show available markups niether will it save the percentage in the one I set up. Please help.
I am creating a report in Report Designer to show all billable entries against a job. The report pulls from the Billing WIP tables - both Billed and Unbilled. Is there a way to mark each row to show which have come from which table? I'm searching for…
Good Morning! I have been with my company for 2 months and I'm just now starting to manipulate TS info. There was a custom built report in our database and when I go in to edit the report - no information comes up on the Design tab to show me how it was…
Hi Chris,
I can think of a few options. Tell me more about your volume of jobs. About how many jobs are open at the end of any month? About how many are completed each month? It would also be helpful to see a job report for one of your typical jobs…
Since the over-under extended report doesn't update for changes in cost to complete that are due to budget variances, what is the best way to update the WIP calculation when multiple jobs are in process? Running a cost to complete report for every job…
when closing out WIP for homebuilder it keeps telling me WIP does not equal Job Costs. When I go into job costs and record it tells me the same thing. what am I missing?
This is my first yr.end dealing with WIP (work in process). Every month I do an entry that reverses the following month. Is the WIP entry done in the last month of our fiscal year also done as a reversing entry, just like the other previous months?
Hi,
We have
1. created W.O.
2. Enter the operation, material and component in production tracking
3. Close the WORK ORDER
run the wip accounting interface.. and stock interface. but accounting journal's are not created. Pls advise
Reg…
Would REALLY like a way to have all the WIP costs transferred automatically from WIP to Direct Expense when I complete and post the invoice. Is there any way to do this??? Or does anyone have an infamous "Sage Workaround"?
We can have hundreds of invoices…
Hi,
Below are the qualifications and context of the question to follow: If you are not a Construction Company tracking Committed Costs for WIP and Estimated Cost to Complete then the following may not be relevant. If you are a Construction Company who…
We have a couple of jobs where all of the WIP records are not coming through to billing from payroll. It's not the complete job where the data isn't flowing through, but a particular cost code. The cost code flows through for other jobs. I have verified…