HOW TO DEDUCT ADVANCE / AMOUNT RECEIVED FROM CUSTOMER IN INVOICE. SO IN INVOICE , AT TOTAL BELOW IT DEDUCT ADVANCE AND SHOW BALANCE. TOTAL XXX ADVANCE (XXX) ------- BALANCE XXX Previous Balance Total balance
send the code or try this [#PartBLLINE Narration] Add:Line:Before:VCH Narration:Anna Advance ;,TermsLine,BankLine [Line:Anna Advance] Left Fields:Simple Prompt,Anna Advance Local:Field : Simple Prompt : Info : $$LocaleString:"Less Advance" Invisible:Not @@IsSales [Field:Anna Advance] Use:Amount Field Storage:MGLAdvance ;Set as: if $$IsEmpty:$MGLAdvancet then "0.00" else $$Value [System: UDF] MGLAdvance : Amount: 3000 ;;======================= [Line: SGrandtotal] Right Field: SledName,Sledamt ;Border: thin Top Local: Field: Sledname :Set as:"Total" Local: Field: Sledamt :Set as: if $$IsEmpty:MGLAdvance then $Amount else $amount-$MGLAdvance Local: Field: Sledname:Style : ssstyle10b Local: Field: Sledamt :Style : ssstyle10b
sir is it possible if we receive advance payment and after entering receipt it will automatic adjust first advance amount in invoice (maintain balance bill by bill option)? so we can get balance details only in bill wise outstanding