DMS KBD

:

? DMS Knowledge Base

1️⃣ Issue: Error while creating E-Invoice (Error: Location field is required)

• Cause:
   Location is missing in ServiceInvoice.
• Actions:
  • Check the error logs.
  • Do not create a bug; create an Asana task and assign it to Sweety Kumari.
  • Run the following query to update the missing location:

sql

CopyEdit

UPDATE tran."ServiceInvoice"

SET "SellerCity" = 'Patna'

WHERE "CompanyId" = 111290 AND "Id" = 31;

2️⃣ Issue: Products are not being filtered based on factory mapping in DMS

• Cause:
  Products are fetched based on the buyer. If the buyer is not mapped to a specific dataset, all products are returned in the response.
• Next Steps:
  This is not a bug. For clarity on this feature’s behavior, please connect with the Product Team.

3️⃣ Issue: Customer Credit Note (E-Credit Request Failed)

• Error:
   E-Credit request failed during creation.
• Steps to check:
   Run:

sql

CopyEdit

SELECT "BuyerCity", * FROM tran."GoodReturn"

WHERE "Id" = 732247 AND "CompanyId" = 10600;

You will notice BuyerCity is NULL.

• Explanation:
  • This is not a bug.
  • The Good Return was created before the SFA dashboard data update, so BuyerCity was not saved in DMS.
  • Data updates via the SFA dashboard do not retroactively update already created data in DMS.
• Action:
   Manually update the BuyerCity if necessary for backend processing.

4️⃣ Issue: Error while creating Sales Invoice (DMS App)

• Error:

vbnet

CopyEdit

LateInitializationError: Field 'buyerrole' has not been initialized

• Cause:
  There is no mapping in FABuyerSellerMappings for:

arduino

CopyEdit

"BHARATKUMAR FOODGRAINS - KALYAN"

• Action:
   Check for relevant distributor mapping using:

sql

CopyEdit

SELECT * FROM "FABuyerSellerMappings"

WHERE "CompanyId" = 193174 AND "SellerId" = 13692886;

✅ Notes:

• Always check logs and database mappings first before creating Asana tasks.
• Align with the Product Team for functional clarification when needed.
• Document changes or queries executed for transparency in root cause analysis.

5) Issue: Error while creating Sales Invoice (DMS App)

• Error:

When the distributor tries to create a Sales Order, after selecting the Salesperson and Beat, the system should automatically display only those outlets filtered for that specific Salesperson and Beat. However, currently, all outlets are being displayed instead of the filtered ones

 Resolution - this is a not applied on super stockiest you can filter out by buyer type only.