Plug-ins > FM Books Connector

Pushing a Build Assembly

(1/2) > >>

jnate:
Greetings;

I'm attempting to modify Build Assemblies in the Quick Books database.  I have added a new table with 4 entries:

gPush_Build_TxnDate
gPush_Build_FullName
gPush_Build_QuantityToBuild
gPush_Build_RefNumber

Next I built a new Layout including these four items.

Finally, I constructed the following script:

Set Error Capture [On}
Allow User Abort [On}
Set Field {Main::gResult; PCQB_RqNew("BuildAssemblyAddRef")
Set Field {Main::gResult; PCQB_RqAddFieldWithValue( "ItemInventoryAssemblyRef::FullName" ; Build Assemblies Push::gPush_Build_FullName )]
Set Field {Main::gResult; PCQB_RqAddFieldWithValue( "TxnDate" ; Build Assemblies Push::gPush_Build_TxnDate )]
Set Field {Main::gResult; PCQB_RqAddFieldWithValue( "RefNumber" ; Build Assemblies Push::gPush_Build_RefNumber )]
Set Field {Main::gResult; PCQB_RqAddFieldWithValue( "QuantityToBuild" ; Build Assemblies Push::gPush_Build_QuantityToBuild )]
Set Field {Main::gResult; PCQB_BeginSession ("";"")
Set Field {Main::gResult; PCQB_RqExecute
Set Field {Main::gResult; PCQB_EndSession

All appears well except, of course, for the fact that when I execute the script nothing happens in QuickBooks and I recieve no error message in Filemaker Pro.

Any Idea what I might have done wrong?  It's a simple script so I'm assuming it's something simple that I messed up.

Thanks in advance for any help and insight.

John Nate

Melinda DePalma:
Please replace PCQB_RqNew("BuildAssemblyAddRef") with PCQB_RqNew("BuildAssemblyAdd") as according to the OSR there should not be a "Ref" on the end.  :o

jnate:
Hi Melinda;

Thanks for the response.  Actually, I had tried both versions (BuildAssemblyAddRef and BuildAssemblyAdd thinking that might be the problem) with the same results.  Nothing updated in QB.

Anything else that might be wrong?

Thanks,
John Nate

Melinda DePalma:
Can you please do some additional error trapping by opening "Script Debugger", "Data Viewer" and walking through each script step to see what is returned. If an !!ERROR!! string is returned then please immediately call PCQB_SGetStatus to obtain a full description of the error. Please let me know.

jnate:
Unfortunately we are on the Standard version of FMP 8 and only the Advanced version has the Debugger.  I could probably download the latest trial version but would testing in 10 to see if this will work in 8 be a valid test?  Do you have any other options?

John Nate

Navigation

[0] Message Index

[#] Next page

Go to full version