FOCUS 6 ERP Expert Needed for Inventory Costing Issue

$30-250 USD

Open

Posted 3 minutes ago

•

Ends in 6 days

$30-250 USD

Paid on delivery

Subject: Seeking FOCUS 6 ERP Expert – Average Cost Issue during Inventory Reposting "I am looking for a FOCUS 6 ERP expert to resolve an issue with Average Costing during inventory Reposting. The current costing formula works correctly under normal conditions. However, we are facing a critical issue when the quantity reaches zero in specific scenarios: Inventory Transfers: When transferring items between warehouses, if the quantity in the source warehouse is cleared (zeroed out) and the quantity in other warehouses is also zero, the average cost is lost. Upon receiving the items at the destination warehouse, the cost remains zero instead of being restored. Sales Returns: If a return occurs for an item that currently has zero quantity in stock, the system fails to recalculate or restore the average cost, leaving it at zero. I need a solution that ensures the cost history is maintained or correctly recalculated during the Reposting process, even when quantities hit zero." Example: transfer stock to other warehouse transfer qty=2,dc=50 dollar and qty become zero recieve other warehouse qty=2 ,dc=0, i want dc=50 usd not zero

Project ID: 40187843

About the project

6 proposals

Open for bidding

Remote project

Active 2 mins ago

Place your bid

Bid amount

USD

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

6 freelancers are bidding on average $97 USD for this job

@professorxwriter

Hello Abdulmalik A., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Accounting, Business Analysis, ERP, Inventory Management, Financial Analysis, Financial Consulting, Database Management, Data Management Lets connect in chat so that We discuss further. Thank You

$140 USD in 7 days

4.9

(17 reviews)

4.9

@swatijain5558

Hello, I am a seasoned FOCUS 6 ERP expert with a proven track record of resolving complex Average Costing issues. I have extensive experience in troubleshooting and optimizing inventory reposting processes to ensure accurate cost calculations even in scenarios where quantities hit zero. I am confident that I can provide a robust solution to maintain cost history integrity and recalculate average costs effectively during inventory transfers and sales returns. Regards, CA. Swati Jain, CPA | Indian CA & CS

$40 USD in 2 days

5.0

(13 reviews)

4.4

@wilfrednjorog

Hi there, I've read your project and understand the critical issue with average costing in FOCUS 6 ERP during inventory reposting. With extensive experience in ERP systems and a strong background in financial analysis and inventory management, I can devise a solution that will maintain and correctly recalculate the cost history, even when quantities reach zero. Let's ensure that your costing formula works seamlessly, especially during inventory transfers and sales returns. Best regards,

$120 USD in 1 day

5.0

(2 reviews)

3.4

@MSaadJaved

Hi Abdulmalik A., I am a FOCUS 6 ERP specialist with strong experience in inventory costing and reposting fixes. I understand the issue: when quantity hits zero during transfers or returns the average cost is lost and later receipts keep cost at zero. I can review your costing routines, transaction history and reposting logic to ensure cost history is preserved or restored when quantities go from zero to positive. I will focus on preserving the last known unit cost, checking posting sequences, and fixing reposting logic so received items regain the correct cost. Please share sample transactions, affected journal entries or database tables so I can diagnose the root cause. You can also view my profile and portfolio for similar work. Best regards, Saad J.

$150 USD in 3 days

5.0

(1 review)

2.5

@anirudhat

I understand exactly the challenge you're facing—your FOCUS 6 system is losing average cost values when inventory quantities hit zero during inter-warehouse transfers and sales returns, because the standard reposting logic discards cost history at the zero-quantity threshold. My approach will involve modifying the costing stored procedures to preserve the last known average cost in a reference field before quantity reaches zero, then implementing logic to retrieve and apply this cost when items re-enter inventory through transfers or returns. I have extensive experience with ERP inventory costing modules and SQL-based financial data management. I can start immediately and would welcome the opportunity to resolve this for you.

$30 USD in 1 day