About former_member212181

former_member212181 · 07-13-2017

While adding AR Invoice based on Delivery note, we are getting below error message. You must select a IGST tax code for integrate business. But in fact both ship from location and ship to location are in the same state If we delete the item co...

Queries Reports for SAP B1 · 07-22-2015

Hi All,I am Unnikrishnan from India-Kerala State, having 5+ years of experience in SAP Business One.Here I am posting some queries reports which may helpful for newcomers.1. Detailed Sales AnalysisDeclare @FDate DateTime, @TDate DateTime, @CardCode V...

Fixed Assets in SAP Business One · 05-19-2015

Fixed Assets Management in SAP B1Road Map Fixed Assets Add-on Fixed Assets Module in 9.0 with enhanced functionality Enhanced in 9.1 Cancel Depreciation Runs Carry Cost Accounting Information from Marketing Documents: ...

Query for Detailed Sales Analysis · 05-05-2015

Hi All,I would like to share detailed sales analysis query which will give all Customer wise, Item wise and sales employee wise sales report in one shot.In this query, From date and To Date are mandatory input parameter where as remaining are optiona...

former_member212181 · 04-23-2015

Hi Experts,We found an issue in SAP B1 9.0 PL 5Created one invoice with 2 Quantity, but in inventory posting relevant to this invoice shows only 1 Qty.For accounting treatment, CoGS Value also considered for 1 Qty. But revenue calculated for 2 qty.If...

former_member212181 · 03-07-2022

Hi Nikunj,In OITL table DocQty and StockQty shows negative figure when stock goes out. So you can make use of that field.Please add below text in your query, Case when T1."DocQty">0 then 'IN' else 'Out' endWarm RegardsUnnikrishnan

former_member212181 · 03-07-2022

Hi Gnanaprakash,Apart from 4 header level + 8 Line level standard JE fields, you can add your own user defined fields in JE window header or line level.So those UDFs in Journal entry window will also be listed for mapping with document data.Looks lik...

former_member212181 · 03-07-2022

Hi Nur,According to me, you have to keep with Production order table as a base table and link issue for production and receipt from production data to itPlease try below script as a sample, and you can make changes according to your requirement. Thi...

former_member212181 · 03-07-2022

Hi Ahmed Esam,"Exchange rate differences" window is for booking "unrealized" gain or loss due to exchange rate differences. It would be nice if you create separate GLs for posting these unrealized gain or loss due to exchange rate differences.These J...

former_member212181 · 06-22-2016

Hello,Sorry for my last reply,Its not a bug. Its an option which helps for fast response in Open items list window.Please refer SAP Note : 1878060 Thanks & RegardsUnnikrishnan

User Statistics

User Activity

you must select a IGST tax code for interstate business

Queries Reports for SAP B1

Fixed Assets in SAP Business One

Query for Detailed Sales Analysis

Bug in SAP B1

Re: Query correction / Column add SAP Business One HANA

Re: How to add new Field name in Reference Field links

Re: OIGE vs OIGN vs OWOR

Re: Exchange Rate gain/loss issue of incoming payment

Re: No sorting on Open Items list - for Sales Orders