Hi,
I created a cost budget line item and created a Project Drop Ship PO on a stock item. I applied a PO Receipt and entered the A/P Bill for the PO.
However, Acumatica is creating a duplicate line item like below:
but when the expense is allocated to the project via A/P it’s offsetting against the correct line item below:
Here are my project preferences on drop shipments:
What I am I doing wrong? Any guidance would help. I am also attaching more screenshots on this issue.
Thanks,
Frances
Best answer by smuddurthi81
This reply has been created with the help of AI
Step 1: Verify the Cost Budget and PO Link
Go to Projects (PM301000).
Open the project and navigate to the Cost Budget tab.
Ensure that:
The Inventory ID in the Cost Budget matches the PO Inventory ID.
The Account Group used in the cost budget is set up correctly.
The UOM and Quantity in the budget align with the PO.
Step 2: Check the Drop-Ship Expense Configuration
Navigate to Project Preferences (PM101000).
In the GL Settings for Unbilled Remainders section, confirm the following:
Use Expense Account From: Project (✔ Correct)
Drop-Ship Receipt Processing: Generate Receipt (✔ Correct)
Record Drop-Ship Expenses: On Receipt Release (✔ Correct)
If your setup matches this, the expense should be applied when the receipt is released. If not, check the next steps.
Step 3: Review the PO and Receipt Processing
Go to Purchase Orders (PO301000) and open the Drop-Ship PO.
Ensure:
The Project and Task fields are populated in the PO.
The correct Account Group is assigned in the PO line.
The PO is linked to the correct project and budget line.
Go to PO Receipts (PO302000) and check:
The Receipt Release Date (Ensure it is posted after PO creation).
The Linked Project Details in the Receipt.
The GL Transactions generated upon receipt.
Step 4: Verify A/P Bill Posting
Open Bills and Adjustments (AP301000).
Locate the A/P Bill linked to the PO and check:
The Project and Task are assigned in the A/P Bill.
The GL Account used matches the Cost Budget account group.
The Expense Subaccount (if applicable) aligns with the project cost code.
The Bill is released and posted.
Go to Project Transactions (PM304000):
Verify how the expense is recorded in the project.
Look for any unexpected offsets or allocations.
Step 5: Manually Adjust if Needed
If the expense is not aligning with the correct cost budget, you may need to manually adjust it:
Go to Project Transactions (PM304000).
Locate the incorrect expense transaction.
Create a Project Cost Adjustment to move it to the correct budget line.
Potential Issues & Fixes
Issue Possible Fix
Expense not applied to the project Check if the expense account in A/P Bill is mapped to a Project Account Group.
Cost applied to incorrect line item Ensure that the Inventory ID in PO matches the Cost Budget line.
Expense not recognized Check if the PO Receipt was released properly and not in an unposted state.
GL accounts mismatch Ensure the expense account for drop-ship items is aligned with the budgeted cost account group.
Final Check
If everything is set up correctly, try releasing the A/P Bill again and check the Project Cost Transactions.
If the issue persists, review GL Account postings in Journals (GL301000) to trace where the expense is being recorded.
This reply has been created with the help of AI
Step 1: Verify the Cost Budget and PO Link
Go to Projects (PM301000).
Open the project and navigate to the Cost Budget tab.
Ensure that:
The Inventory ID in the Cost Budget matches the PO Inventory ID.
The Account Group used in the cost budget is set up correctly.
The UOM and Quantity in the budget align with the PO.
Step 2: Check the Drop-Ship Expense Configuration
Navigate to Project Preferences (PM101000).
In the GL Settings for Unbilled Remainders section, confirm the following:
Use Expense Account From: Project (✔ Correct)
Drop-Ship Receipt Processing: Generate Receipt (✔ Correct)
Record Drop-Ship Expenses: On Receipt Release (✔ Correct)
If your setup matches this, the expense should be applied when the receipt is released. If not, check the next steps.
Step 3: Review the PO and Receipt Processing
Go to Purchase Orders (PO301000) and open the Drop-Ship PO.
Ensure:
The Project and Task fields are populated in the PO.
The correct Account Group is assigned in the PO line.
The PO is linked to the correct project and budget line.
Go to PO Receipts (PO302000) and check:
The Receipt Release Date (Ensure it is posted after PO creation).
The Linked Project Details in the Receipt.
The GL Transactions generated upon receipt.
Step 4: Verify A/P Bill Posting
Open Bills and Adjustments (AP301000).
Locate the A/P Bill linked to the PO and check:
The Project and Task are assigned in the A/P Bill.
The GL Account used matches the Cost Budget account group.
The Expense Subaccount (if applicable) aligns with the project cost code.
The Bill is released and posted.
Go to Project Transactions (PM304000):
Verify how the expense is recorded in the project.
Look for any unexpected offsets or allocations.
Step 5: Manually Adjust if Needed
If the expense is not aligning with the correct cost budget, you may need to manually adjust it:
Go to Project Transactions (PM304000).
Locate the incorrect expense transaction.
Create a Project Cost Adjustment to move it to the correct budget line.
Potential Issues & Fixes
Issue Possible Fix
Expense not applied to the project Check if the expense account in A/P Bill is mapped to a Project Account Group.
Cost applied to incorrect line item Ensure that the Inventory ID in PO matches the Cost Budget line.
Expense not recognized Check if the PO Receipt was released properly and not in an unposted state.
GL accounts mismatch Ensure the expense account for drop-ship items is aligned with the budgeted cost account group.
Final Check
If everything is set up correctly, try releasing the A/P Bill again and check the Project Cost Transactions.
If the issue persists, review GL Account postings in Journals (GL301000) to trace where the expense is being recorded.
+8
what this indicates is that the GL account in COGS mat is different from the GL account that’s on the item profile which is why it’s posting to a different account group. I would see if you are able to combine the gl accounts and put all the material gl accounts into one account group so that the system doesn’t create a new line for the budget.
+2
Thanks for your help.
what this indicates is that the GL account in COGS mat is different from the GL account that’s on the item profile which is why it’s posting to a different account group. I would see if you are able to combine the gl accounts and put all the material gl accounts into one account group so that the system doesn’t create a new line for the budget.
Thanks for your help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
