Skip to main content

I would like to add an upload button to be able to upload an excel file with the lines an AP payment should be applied. 

 

What do I need to do in the customizations? 

@Jeff96 Try creating a graph extension for the class that defines the view where you want to add the Upload button. I guess it is the Documents to Apply tab where the Adjustments view is the one:
 

In this case, the Adjustments view is defined inside the MultiCurrency graph extension, so, try something like this to override it by adding the PXImport attribute on top of it:
 

public class MultiCurrencyExtension : PXGraphExtension<MultiCurrency,APPaymentEntry>
{
rPXCopyPasteHiddenView]
public PXSelectJoin<APAdjust,
LeftJoin<APInvoice, On<APInvoice.docType, Equal<APAdjust.adjdDocType>,
And<APInvoice.refNbr, Equal<APAdjust.adjdRefNbr>>>,
LeftJoin<APTran, On<APInvoice.paymentsByLinesAllowed, Equal<True>,
And<APTran.tranType, Equal<APAdjust.adjdDocType>,
And<APTran.refNbr, Equal<APAdjust.adjdRefNbr>,
And<APTran.lineNbr, Equal<APAdjust.adjdLineNbr>>>>>>>,
Where<APAdjust.adjgDocType, Equal<Current<APPayment.docType>>,
And<APAdjust.adjgRefNbr, Equal<Current<APPayment.refNbr>>,
And<APAdjust.released, NotEqual<True>>>>> Adjustments;
}

 


@Jeff96 Can you help a non-programmer understand how your customization will differ from the existing Excel button?

 


@Jeff96Can you help a non-programmer understand how your customization will differ from the existing Excel button?

 

I’m also not a programmer… There is currently no excel upload button, only a download button.


doh, I confused buttons.


Reply