relationships

[gnp]

Is there any relationship that could be made between the PurchParmTable and
the VendTrans Tables?

[Max Belugin [MVP]]

I am not sure, but try to find VendInvoiceJour (and other kinds of journal
generated by such parameters)

PurchParmTable.ParmID == VendInvoiceJour.ParmID
&&
VendInvoiceJour.ledgerVoucher == VendTrans,Voucher

can you describe a more general problem?

[gnp]

The problem is that I want to add something like "Additional Invoice
Information" with his own table. So for each purchase order i need to add
that.

Vendtrans has all the Invoices, so once I register the Invoice for a
PurchaseOrder, I have the option to add "Additional Invoice Information",
but I need the link between the VendTrans and PurchParmTable or any other
table to use it in my new Table "Additional Invoice Information".

Something similar was happening with the LedgerJournalTrans and my new
table...The LedgerJournalTrans has a VendTransId, so once I register in the
LedgerJournalTrans I get the id created in the VendTrans and then I can add
the VendTransId in my "Additional Invoice Information". So in this case I
have a link between LedgerJournalTrans and The VendTrans Table, that I can
use later.

Hope this was understandable.

Post by Max Belugin [MVP]
I am not sure, but try to find VendInvoiceJour (and other kinds of journal
generated by such parameters)
PurchParmTable.ParmID == VendInvoiceJour.ParmID
&&
VendInvoiceJour.ledgerVoucher == VendTrans,Voucher
can you describe a more general problem?
--
my blog: http://axcoder.blogspot.com
freeware tabbed interface for ax: http://axaptapedia.com/Tabax

Post by gnp
Is there any relationship that could be made between the PurchParmTable and
the VendTrans Tables?

[Max Belugin [MVP]]

As far as I know, ParmTables are not meant to store historical data, maybe
you can modify invoice posting (VendInvoiceJour.initFromPurchParmTable for
example) and store copy of your additional parameters in the Invoice directly
or even copy them to VendInvoiceTrans (it is harder, maybe VendVoucher must
be modified)
--
my blog: http://axcoder.blogspot.com
freeware tabbed interface for ax: http://axaptapedia.com/Tabax

Post by gnp
The problem is that I want to add something like "Additional Invoice
Information" with his own table. So for each purchase order i need to add
that.
Vendtrans has all the Invoices, so once I register the Invoice for a
PurchaseOrder, I have the option to add "Additional Invoice Information",
but I need the link between the VendTrans and PurchParmTable or any other
table to use it in my new Table "Additional Invoice Information".
Something similar was happening with the LedgerJournalTrans and my new
table...The LedgerJournalTrans has a VendTransId, so once I register in the
LedgerJournalTrans I get the id created in the VendTrans and then I can add
the VendTransId in my "Additional Invoice Information". So in this case I
have a link between LedgerJournalTrans and The VendTrans Table, that I can
use later.
Hope this was understandable.

Post by Max Belugin [MVP]
I am not sure, but try to find VendInvoiceJour (and other kinds of journal
generated by such parameters)
PurchParmTable.ParmID == VendInvoiceJour.ParmID
&&
VendInvoiceJour.ledgerVoucher == VendTrans,Voucher
can you describe a more general problem?
--
my blog: http://axcoder.blogspot.com
freeware tabbed interface for ax: http://axaptapedia.com/Tabax

Post by gnp
Is there any relationship that could be made between the PurchParmTable and
the VendTrans Tables?