x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 117 subscribers
  • Views 1301 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
44
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
js-goose

Error #12: File does not exist (or already exists) File: FL_Options

SUGGESTED
Posted By

Hello everyone!

I'm attempting to update records in `PO_ReceiptHeader` and `PO_ReceitDetail` through SAGE 100 SData (via a custom built web app), however I keep running into this error :

```<?xml version="1.0" encoding="utf-8"?>

<sdata:diagnoses xmlns="">schemas.sage.com/.../1" xmlns:xs="">www.w3.org/.../XMLSchema" xmlns:atom="">http://www.w3.org/2005/Atom" xmlns:sdata="">schemas.sage.com/.../1" xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xmlns:opensearch="">a9.com/.../" xmlns:sync="">schemas.sage.com/.../1" xmlns:sme="">schemas.sage.com/.../2007" xmlns:http="">schemas.sage.com/.../1">
  <sdata:diagnosis>
    <sdata:severity>error</sdata:severity>
    <sdata:sdataCode>ApplicationDiagnosis</sdata:sdataCode>
    <sdata:applicationCode />
    <sdata:message>Error #12: File does not exist (or already exists) File: FL_Options</sdata:message>
    <sdata:stackTrace />
    <sdata:payloadPath />
  </sdata:diagnosis>
</sdata:diagnoses>```

Here is the payload that produces the error: 
```payload <entry xmlns:atom="">http://www.w3.org/2005/Atom" xmlns:xs="">www.w3.org/.../XMLSchema" xmlns:cf="">www.microsoft.com/.../2005" xmlns="">http://www.w3.org/2005/Atom" xmlns:sdata="">schemas.sage.com/.../1" xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xmlns:opensearch="">a9.com/.../" xmlns:sync="">schemas.sage.com/.../1" xmlns:sme="">schemas.sage.com/.../2007" xmlns:http="">schemas.sage.com/.../1"><sdata:payload><PO_ReceiptHeader sdata:uri="sdata/MasApp/MasContract/PLU/PO_ReceiptHeader('G;058650')" xmlns=""><PrepaidFreightAmt>0.00</PrepaidFreightAmt><UDF_RECEIVER_APPROVED>Y</UDF_RECEIVER_APPROVED><UDF_RECEIVER_DATE>2020-05-19</UDF_RECEIVER_DATE><UDF_RECEIVER_NAME>jsexton</UDF_RECEIVER_NAME><UDF_RECEIVER_TIME>1101</UDF_RECEIVER_TIME></PO_ReceiptHeader></sdata:payload></entry>```

I've looked for posts relating specifically to Error 12 and File: FL_Options but had little luck in finding anything.

I'd love some feed back on what I'm doing wrong or what I need to change. Also if you need to see my function call I'd be happy to share that as well. If there is any information missing I do apologize in advance - I'm new around here Slight smile  I'll be happy to provide anything you all might need to help diagnose the problem.

Thank you for any and all help you may be able to provide.

Top Replies

  • 0
    SUGGESTED

    FL = Sage Fixed Assets Link, a separate integration module for Sage 100.  Do you know if the system you are integrating with has Fixed Assets?  

    Also, are you potentially populating any of the columns that deal with fixed assets in the receipt detail?  (AssetAccount = Y or AssetTemplate)?

    This may be the issue, if the Asset Account = "Y" it maybe looking to internally reference some fixed assets link tables that do not exist on the system.

    Hope this helps, Elliott

  • 0 in reply to jepritch

    Hi Elliot, thank you for your quick response!  I'm not 100% sure on the Fixed Assets module as me nor the other developer have run into that yet.

    As far as the AssetAccount and AssetTemplate I am not setting those.  Looking at my test Receipt of Goods in the database, I can see that my AssetAccount lines are set to N and the AssetTemplate lines for that same record are all blank.

    Here are the columns I'm attempting to populate with the HEADER call:

    `<PO_ReceiptHeader sdata:uri="sdata/MasApp/MasContract/` +
          GLOBAL_VARIABLES.gCompany +
          `/PO_ReceiptHeader('${object.receiptType};${object.receiptNo}')" xmlns="">` +
          `<PrepaidFreightAmt>0.00</PrepaidFreightAmt>` +
          `<UDF_RECEIVER_APPROVED>Y</UDF_RECEIVER_APPROVED>` +
          `<UDF_RECEIVER_DATE>${todaydate}</UDF_RECEIVER_DATE>` +
          `<UDF_RECEIVER_NAME>${receiver}</UDF_RECEIVER_NAME>` +
          `<UDF_RECEIVER_TIME>${time}</UDF_RECEIVER_TIME>` +
          `</PO_ReceiptHeader>`

    And here are the columns I'm attempting to populate with the DETAIL call:

    `<PO_ReceiptDetail sdata:uri="sdata/MasApp/MasContract/` +
          GLOBAL_VARIABLES.gCompany +
          `/PO_ReceiptDetail('${object.receiptType};${object.receiptNo};${object.lineKey}')" xmlns="">` +
          `<AllocatedFreightAmt>0.00</AllocatedFreightAmt>` +
          `<QuantityReceived>${object.newQtyReceived}</QuantityReceived>` +
          `</PO_ReceiptDetail>`

*Community Hub is the new name for Sage City