What determines if an invoice shows up in the selection grid: AR/Transaction/Enter cash receipt?

[captsnappy]

What determines if an invoice shows up in the selection grid: AR/Transaction/Enter cash receipt/Payment on account?

Back story: we have a customized SO shipping routine that was interrupted by hardware failure. I've gone under the hood to attempt to complete the shipping process and invoice creation using VFP 5.0. This is SBT 5.0i.

So far so good, but the open invoices do not show up in the selection grid when attempting to apply payment. Looking in arcash.prg I cannot figure out how invoices are determined for display in that grid.

I see no apparent differences between invoices that do show up and those that do not in armast01.dbf/artran01.dbf.

Any ideas?

Thank you.

trey

Trey Harris
hdb
Houston

 

[captsnappy]

I guess it wanted to have something in the currid field. The rogue invoices did not have USD in that field. After entering USD they show up.


Trey Harris
hdb
Houston

 

[mandaragit]

Hi Trey,

Wow, nice catch up, Trey, salute to you. And yes, that's correct. A null value of currencyID in armastxx.dbf will not visible in any form of AR offsetting (enter cash receipt or apply credits module). But in some SBT engine (the same version), an empty currid of armastxx.dbf is fine. It depends on how it was being configured. And your setting requires a currencyID (currid).

I just wanna make it clear incase other users can read this thread and finds their SBT doesn't requires this data to be visible in the offsetting of the receivable.

Have a blessed day!



junmagoncia

 

[captsnappy]

Thank you, junmagoncia!

Trey Harris
hdb
Houston