Direct Link from Ledger entry to Invoice & Credit Memo c

mhitendra
mhitendra Member Posts: 6
edited 2008-06-10 in NAV/Navision Classic Client
Hi,

We want to have a direct link from the Ledger entry screen to the Invoice Card & Credit memo card. Once this is achieved we need to add this as a subform to the Customer Form.

We managed to get the direct link (in the Ledger entries form) by creating a button and setting its properties to link the No. in the Posted Invoice Form to the Document No. in the Cust. Ledger Form. But how can we make it dynamically select a Credit Memo card when a Credit memo entry is selected.

Also, the new challange is, when we try to add the 'Customer Ledger form' as a SUBFORM to the main Customer Form, it displays the ledger entries in the same screen fine but when clicked on the Invoice card there (present in the sub form) it gives the following error.
A value in the filter 'AHRAM UN P.CODE.11511' in the No. field in the Sales Invoice Header table is too long for the field type.

Type: Code20

The value it picks up is from the Address2 in the Main Customer Form.

Can you please help us out here.

Thanks

Comments

  • DaveT
    DaveT Member Posts: 1,039
    Hi Mhitendra,


    Just suggested something similar to solve this - check out this post

    http://www.mibuso.com/forum/viewtopic.php?t=26190
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • apertierra
    apertierra Member Posts: 61
    Or start by reading the developer's guide.

    1) The values used to filter can't be bigger than the size of the field filtered. Based on the description of the issue seems like the "no." field is being filtered by using the "description" field in the customer ledger entry instead of the document no. of the entry.
    2) The filters to match a customer ledger entry with the posted document are not just the document no., but also the posting date.

Categories